package com.study.springmvc.dao.mapper;

import com.study.springmvc.model.Student;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface StudentMapper {
    Student findStudentByNameAndPwd(@Param("name") String name, @Param("pwd") String pwd);

    int add(@Param("student") Student student);

    List<Student> findStudentList(@Param("offset") int offset, @Param("pageSize") int pageSize);

    List<Student> findStudentListNoPageParam();

    int getStudentCount();

    Student findStudentByStuGid(@Param("stuGid") String stuGid);

    int updatePwdByStuGid(@Param("pwd") String pwd, @Param("stuGid") String stuGid);

    int deleteByStuGid(@Param("stuGid") String stuGid);
}
